Generating scripts using the Import wizard
Use the Import wizard to carry out auto generation.
Procedure
- To access the Import Wizard, click the Scripts tab.
- Click the Control file.
- Click the Importers button .
Source Type
From here you can import from several source types, these are:
- ODBC Importer
- Excel Importer
- Oracle Importer
- DAO Importer
- ADO Importer.
The data populating the Import Wizard will depend on the source type used.
Source Configuration
| Connection Information | The information required for the load. Click the Browse button and enter the appropriate information. |
| Data Source Item | The item to be imported from the specified connection (typically a table or query string). |
| Source Options | The option associated with the specified connection. For example a query timeout or rowset size. |
Destination Configuration
| Database Name | Enter the database name to be created from the data source. |
| Table Name | This displays the table's attributes and is taken from the Table Import field of the source type of the Import Wizard. |
| Update Method | Select the appropriate Update Method from the drop-down list, the options are:
REFRESH: Replaces all data currently held in the destination table. UPDATE: Compares and replaces all changes based on key fields. APPEND: Adds all data from the source table to the end of the destination table. |
| Key Name | Name of the key to be used in updating the table. If the update method chosen is UPDATE, a database key must be specified. |
Transfer Options
Use Transfer Options if you are having problems with the import and want to test a sample number of records.
| Row Reporting Frequency |
Allows you to see when a specified number of rows has been imported from the Loader screen.
|
||
| Sample Size | Number of records for import | ||
| Dump File | The name and address of a text file if this is present, all records read from the source will be outputted to a file instead of an Alterian database. This can be used with Sample Size to specify a number of records written to the text file). |
Buttons
| Refresh | Updates the fields. |
| Generate/OK | Adds the data to the Script. If you have opened the Import Wizard from the button, Generate is active. Click Generate to add an entry to the Control file. You can then add multiple entries to the script. If you have opened the Import Wizard by double-clicking on the file, the OK button is activated and the screen is pre-populated with information. You can only add the one set of data to the Control file. |
| Close | Closes the screen returning to the Loader Scripts page. |
Data Viewer
| Offset | Specifies the sequence of the fields in the source. | ||
| Field Name |
Specifies the name of each field as it appears in the data source.
|
||
| Type | Engine Data type, for example text, integer, real. The destination type can be modified if necessary, in which case the width and format specification may also need to be changed. | ||
| Width | Specifies the exact width of the field in Engine. | ||
| Format | Selects the required Engine field format option from the drop-down box. The Format option is not active for the options TEXT, UTEXT, INTEGER and UINTEGER. | ||
| Import Y/N | The table entry can be omitted by clicking on the Import Y/N field and selecting No. The original selections can be restored using the Refresh button. |
Using the Import Wizard
When you have completed the Source Type configuration process, several of the fields will be populated with data.
If Import Y/N has any value other than Yes , the field will not be selected for import.
Script Generation Mode
(Launched from button)
When you are satisfied that all relevant information has been provided, click Generate Script to create the script according to the values entered.
While in script generation mode more data table definitions can be added by selecting the desired table and repeating the above process.
When you have finished adding or modifying tables, be aware that the table details are not saved until you return to the Scripts screen.
Script Update Mode
(Launched from script)
When you have completed any necessary modifications click OK or cancel to return to the Scripts screen.
